SELECT ident, naziv,IF( slika_1 IS NULL ,'/gfx/_box-images/ni_slike.jpg',slika_1) as slika_1,cena_pred_akcijo,cena FROM _produkti_aures
WHERE kategorija = 'Čelade Airoh' AND pod_kategorija = 'Integralne'
ORDER BY cena LIMIT 9,9
Airoh Spark Rock'N'Roll
199,99 €
Airoh Spark Cyrcuit Black Matt
199,99 €
Airoh Spark Flow Pink
199,99 €
Airoh Spark SCALE črna/siva
209,99 €
Airoh Spark RISE RED GLOSS
219,99 €
Airoh Spark RISE BLACK MATT
219,99 €
Airoh Spark SHOGUN PINK MATT
219,99 €
Airoh ST501 SQUARE BLUE/RED GLOSS
319,98 €
Airoh ST501 POWER MATT
319,99 €